package org.zn.etl.jdbc;

import java.sql.Types;
import java.util.Set;

import com.google.common.collect.Sets;

public class TypeSets {
	
	
	public static Set<String> STRING_TYPE = Sets.newHashSet("varchar", "varchar2", "char", "bpchar", "text", "clob","nchar","rowid");
	public static Set<String> INT_TYPE = Sets.newHashSet("int", "integer","int2","int4","bit");
	public static Set<String> LONG_TYPE = Sets.newHashSet("long","int8","bigint","bigint unsigned");
	public static Set<String> DATE_TYPE = Sets.newHashSet("date", "timestamp", "datetime");
	public static Set<String> DECIMA_LTYPE = Sets.newHashSet("num","number","numeric","decimal");
	public static Set<String> BYTES_TYPE = Sets.newHashSet("blob");
	public static Set<String> DOUBLE_TYPE = Sets.newHashSet("flot","double","float4","float8");
	public static Set<String> BOOLEAN_TYPE = Sets.newHashSet("boolean");
	 
	
	public static Set<Integer> STRING_TYPE_INT=Sets.newHashSet(Types.VARCHAR,Types.NVARCHAR,Types.CHAR,Types.CLOB,Types.NCHAR,Types.NCLOB);
	public static Set<Integer> INT_TYPE_INT=Sets.newHashSet(Types.INTEGER,Types.SMALLINT,Types.TINYINT);
	public static Set<Integer> LONG_TYPE_INT=Sets.newHashSet(Types.BIGINT,Types.NUMERIC,Types.BIGINT);
	public static Set<Integer> DATA_TYPE_INT=Sets.newHashSet(Types.DATE,Types.TIMESTAMP,Types.TIME);
	public static Set<Integer> DECIMA_LTYPE_INT=Sets.newHashSet(Types.DECIMAL,Types.NUMERIC);
	public static Set<Integer> BYTES_TYPE_INT=Sets.newHashSet(Types.BLOB);
	public static Set<Integer> DOUBLE_TYPE_INT=Sets.newHashSet(Types.FLOAT,Types.DOUBLE,Types.NUMERIC);
	public static Set<Integer> BOOLEAN_TYPE_INT=Sets.newHashSet(Types.BOOLEAN);
	
	
	
	
	

}
